﻿<?xml version="1.0" encoding="utf-8" ?>
<healthcheck name="SiteInformation" description="Site Information">
  <tab name="General" description="General" type="list" active="">
    <fields>
		<field name="BuildNumber" description="Service Pack Level" props="" value="5931=RTM;6221=SP1;6487=SP2" format="" queryID="1" />
		<field name="InstallDir" description="Install Directory" props="" value="" format="" queryID="1" />
		<field name="ReportingSiteCode" description="Parent site" props="" value="" format="" queryID="1" />
		<field name="ServerName" description="Server Name" props="" value="" format="" queryID="1" />
		<field name="SiteCode" description="Site Code" props="" value="" format="" queryID="1" />
		<field name="SiteName" description="Site Name" props="" value="" format="" queryID="1" />
		<field name="Type" description="Type" props="" value="2=Primary Site;1=Secondary Site" format="" queryID="1" />
		<field name="Version" description="Version" props="" format="" queryID="1" />
		<field name="IsR2CapableRTM" description="R2/R3 Instalado" props="value" value="31=R2;63=R3" format="" queryID="2" />
		<field name="IISSSLState" description="Site Mode" props="value" value="0=Mixed mode;31=Native mode;63=Native mode;95=Native mode;127=Native mode" format="" queryID="3" />
	</fields>
	<sqls>
	    <sql type="site" id="1" query="SELECT * FROM SMS_Site where SiteCode = '@@SITECODE@@'" />
		<sql type="site" id="2" query="SELECT * FROM SMS_SCI_SiteDefinition WHERE SiteCode = '@@SITECODE@@'" />
		<sql type="site" id="3" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_SITE_COMPONENT_MANAGER'" />
	</sqls>
  </tab>
  <tab name="WakeOnLan" description="Wake On Lan" type="list" active="">
    <fields>
		<field name="Flag" description="Status" props="" value="2=Disabled;6=Enabled" format="" queryID="1" />
		<field name="SendRetryMax" description="Transmission retries" props="value" value="" format="" queryID="1" />
		<field name="SendRetryInterval" description="Transmission retry delays (minutes)" props="value" value="" format="1" queryID="1" />
		<field name="SendThrottleMax" description="Transmission maximum" props="value" queryID="1" format="" value="" />
		<field name="SendThrottleInterval" description="Transmission maximum wait (seconds)" props="value" value="" format="" queryID="1" />
		<field name="MaxThreads" description="Transmission threads" props="value" value="" format="" queryID="1" />
		<field name="SendMode" description="Send Mode" props="value" value="1=Unicast;2=Mulsticast" format="" queryID="1" />
		<field name="Port" description="Port" props="value" value="" format="" queryID="1" />
		<field name="ScheduleOffset" description="Transmission offset (minutes)" props="value" value="" format="" queryID="2" />
		<field name="SendWOLPacketOnly" description="Use wake-up packets only" props="value" value="0=Disabled;1=Enabled" format="" queryID="2" />
		<field name="SendWSMANPacketOnly" description="Use power on commands only" props="value" format="" value="0=Disabled;1=Enabled" queryID="2" />
		<field name="SendWOLAndWSMAN" description="Use power on if the computers support this technology; otherwise, use wake-up packets" props="value" value="0=Disabled;1=Enabled" format="" queryID="2" />
	</fields>
	<sqls>
	    <sql type="site" id="1" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_WAKEONLAN_COMMUNICATION_MANAGER'" />
		<sql type="site" id="2" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_WAKEONLAN_MANAGER'" />
	</sqls>
  </tab>
  <tab name="Ports" description="Ports" type="list" active="">
    <fields>
		  <field name="IISPortsList" description="Client Requests HTTP (TCP) port" props="value1" value="" format="" queryID="1" />
		  <field name="IISSSLPortsList" description="Client Requests HTTPS (TCP) port" props="value1" value="" format="" queryID="1" />
		  <field name="IISPreferedPort" description="Client Requests HTTP default port" props="value1" value="" format="" queryID="1" />
		  <field name="IISSSLPreferedPort" description="Client Requests HTTPS default port" props="value1" value="" format="" queryID="1" />
		  <field name="IISWebSiteName" description="Use custom website" props="value" value="0=Disabled;1=Enabled" format="" queryID="1" />
		  <field name="Port" description="Wake on LAN (UDP) port" props="value" value="" format="" queryID="2" />
	  </fields>
	  <sqls>
	      <sql type="site" id="1" query="select * from sms_sci_component where sitecode='@@SITECODE@@'and componentname='SMS_MP_CONTROL_MANAGER'" />
	      <sql type="site" id="2" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_WAKEONLAN_COMMUNICATION_MANAGER'" />
	  </sqls>
  </tab>
  <tab name="Advanced" description="Advanced" type="list" active="">
    <fields>
      <field name="Registration HardwareID Conflict Resolution" description="Conflicting records" props="value" value="0=Automatically create new client records for duplicate hardware IDs;1=Manually resolve conflicting records" format="" queryID="1" />
      <field name="Update Active Directory" description="Publish this site in Active Directory Domain Services" props="value" value="0=Disabled;1=Enabled" format="" queryID="2" />
      <field name="Update DNS names" description="Publish the default management point in DNS (Intranet only)" props="value" value="0=Disabled;1=Enabled" format="" queryID="2" />
      <field name="Allow unknown child sites" description="Require secure key exchange between sites" props="value" value="1=Disabled;0=Enabled" format="" queryID="2" />
    </fields>
    <sqls>
      <sql type="site" id="1" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_SITE_COMPONENT_MANAGER'" />
      <sql type="site" id="2" query="select * from sms_sci_sitedefinition where sitecode='@@SITECODE@@'" />
    </sqls>
  </tab>
  <tab name="SiteMode" description="SiteMode" type="list" active="IsMixedMode">
    <fields>
      <field name="IISSSLState" description="Site Mode" props="value" value="0=Mixed mode;31=Native mode;63=Native mode;95=Native mode;127=Native mode" format="" queryID="1" />
      <field name="Auto Approval" description="Specify how to approve computers joining this site" props="value" value="0=Manually approve each computer;1=Automatically approve computers in trusted domains (recommended);2=Automatically approve all computers (not recommended)" format="" queryID="1" />
      <field name="Send NAA To All Clients" description="This site only contains ConfigMgr 2007 clients" props="value" value="1=Disabled;0=Enabled" format="" queryID="2" />
      <field name="Use Encryption" description="Encrypt data before sending to Management Point" props="value" value="0=Disabled;1=Enabled" format="" queryID="3" />
    </fields>
    <sqls>
      <sql type="site" id="1" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_SITE_COMPONENT_MANAGER'" />
      <sql type="site" id="2" query="select * from sms_sci_clientcomp where sitecode='@@SITECODE@@' and clientcomponentname='Software Distribution'" />
      <sql type="site" id="3" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_POLICY_PROVIDER'" />
    </sqls>
  </tab>
  <tab name="SiteMode" description="SiteMode" type="list" active="IsNativeMode">
    <fields>
      <field name="IISSSLState" description="Site Mode" props="value" value="0=Mixed mode;31=Native mode;63=Native mode;95=Native mode;127=Native mode" format="" queryID="1" />
      <field name="SigningCertificate" description="Site server signing certificate thumbprint" props="value1" value="" format="" queryID="1" />
      <field name="RootCACertificates" description="Osd Root CA certificate" props="list#Values" value="" format="" queryID="1" />
      <field name="IISSSLState" description="Enable CRL checking on clients" props="value" value="31=Disabled;63=Enabled;95=Disabled;127=Enabled" format="" queryID="1" />
      <field name="IISSSLState" description="Allow HTTP communication for roaming and site assignment" props="value" value="31=Disabled;63=Disabled;95=Enabled;127=Enabled" format="" queryID="1" />
      <field name="Certificate Store" description="Client Certificate store" props="value1" value="" format="" queryID="1" />
      <field name="Certificate Selection Criteria" description="Certificate criteria" props="value1" value="" format="5" queryID="1" />
      <field name="Select First Certificate" description="If multiple certificates match criteria" props="value" value="0=Fail selection and send error message;1=Select any certificate that matches" format="" queryID="1" />
    </fields>
    <sqls>
      <sql type="site" id="1" query="select * from sms_sci_component where sitecode='@@SITECODE@@' and componentname='SMS_SITE_COMPONENT_MANAGER'" />
    </sqls>
  </tab>
</healthcheck>